The New York Police Department (NYPD) budget reduction between fiscal years 2020 and 2021 has left unease for many New York locals. At the same time, NYPD is also partnering with schools offering public safety service, such as Columbia shuttles partnered with Via. The city-funded operating budget is projected to decrease by $345 million or almost 7% from 2020 (Pietrzak, 2020). Now is the opportunity to rebalance officer deployment based on analytics that identify areas of high crime concentration, as well as promote and apply the public safety service, such as shuttles, to other needed neighborhoods. This would in turn, increase efficiency and productivity of the police force by accurately deploying the force based on concentration of crimes and easing the minds of local residents who may believe they will be left unprotected and unsafe. In addition, it would help the NYPD improve its image. We want to start the analysis and this project by asking two important questions:
Understanding these questions would help us provide efficient and effective training and distribution of the police force, and allow the NYPD to identify which neighborhood is in need of services and the audiences to communicate with.
Based on historical analysis, we can predict what specific crimes will occur with consideration to location. Once we understand the types of crimes that occur, we can then reduce training and turnover costs by providing more accurate police training specific to those crimes. In areas where police officers will be less involved, the analytics can allow the teams to market precautionary warnings or other solutions to the public if there is a crime within a certain mile radius from where people are located. In the below graphs we have identified that dangerous drugs chargers lead the largest crime offense with assault being the second highest.
Graph 2.1 shows the alarming increased trajectory of the number of crimes from 2019 to 2020, by month, in Columbia’s precinct.
After knowing the number of crime cases, the team would like to know more about the crimes’ characteristic, as a result, we emphasized the crime suspects’ gender and age distributions.
This graph shows in each age group, the crimes’ distribution of male and female, red representing female while blue representing male.
There is a large crime rate in west Harlem and near Morningside parks according to the graph below, and unfortunately these neighborhoods are just near Columbia University campus. Thus, in order to increase the safety and security of Columbia University students, we propose a new distribution and availability of free shuttle service provided by Columbia Transportation and NY Public Safety. After gaining knowledge regarding geography and time distribution of crime, we can further design a corresponding shuttle coverage depending on those time and places. (e.g., if during holiday the crime rate near a certain park is higher, we can extend our shuttle services there). The below graphs show the number of crimes that occur in specific neighborhoods in New York City. There is a large crime rate in Columbia’s precinct. Also, in order to summarize all the required data we just emphasized, we are planing to link all the graphs we plotted into one dashboard using Tableau.
This dashboard is consist of 3 graphs, the top graph is the map of New York, The point is summarized by neighborhoods, each point representing a neighborhood in New York, the bigger and darker the point, the more crimes happened in this neighborhood. When clicking the point on the map, more details of the crime information will show up in the bottom two graph. The left graph showing the top 10 kinds of crime happened in the neighborhood selected, while for the right graph is a pie chart showing the age distribution of the crime suspects in the selected neighborhood.
With the visibility of crimes in the above graphs, this analysis and project would help NYPD operate more efficiently and effectively. The NYPD could use the remaining resources to offer more services like random petrol or shuttles, and communicate with the geographic groups that are in the more dangerous neighborhood. Over this can help increase public safety, save the NYPD budget, and build a better NYPD image.
In conclusion, based on the graph the team plotted, we can see that neighborhood of Harlem has the most number of crime occurred, and in the fitst quarter of the year, the number of crimes occurred are more than rest part of the year in both 2019 and 2020. Thus, we suggest the NYPD put more efforts near the neighborhood of Harlem, and increase the patrols during the month from January to March. According to all the crimes occurred, taking dangerous drugs tends to be occur the most among most of the neighborhoods, and the number of cases of this type of crime occupies a dominant position in all cases.
## Member_Name Contribution_Score
## 1: Djokovic, Amira 10
## 2: Bai, Jiawei 10
## 3: Chan, Ching Ching 10
## 4: Ko, Ting Han 10
## 5: Djokovic, Amira 10## [1] "Pietrzak, Adrian. “Was the NYPD Budget Cut by $1Billion?” August 13, 2020."## [1] "https://cbcny.org/research/was-nypd-budget-cut-1-billion"## [1] "https://data.cityofnewyork.us/Public-Safety/NYPD-Arrests-Data-Historic-/8h9b-rp9u"## [1] "https://www1.nyc.gov/site/nypd/bureaus/patrol/precincts/26th-precinct.page"